package com.weimall.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class BmSplbExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BmSplbExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBmIsNull() {
            addCriterion("BM is null");
            return (Criteria) this;
        }

        public Criteria andBmIsNotNull() {
            addCriterion("BM is not null");
            return (Criteria) this;
        }

        public Criteria andBmEqualTo(String value) {
            addCriterion("BM =", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmNotEqualTo(String value) {
            addCriterion("BM <>", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmGreaterThan(String value) {
            addCriterion("BM >", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmGreaterThanOrEqualTo(String value) {
            addCriterion("BM >=", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmLessThan(String value) {
            addCriterion("BM <", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmLessThanOrEqualTo(String value) {
            addCriterion("BM <=", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmLike(String value) {
            addCriterion("BM like", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmNotLike(String value) {
            addCriterion("BM not like", value, "bm");
            return (Criteria) this;
        }

        public Criteria andBmIn(List<String> values) {
            addCriterion("BM in", values, "bm");
            return (Criteria) this;
        }

        public Criteria andBmNotIn(List<String> values) {
            addCriterion("BM not in", values, "bm");
            return (Criteria) this;
        }

        public Criteria andBmBetween(String value1, String value2) {
            addCriterion("BM between", value1, value2, "bm");
            return (Criteria) this;
        }

        public Criteria andBmNotBetween(String value1, String value2) {
            addCriterion("BM not between", value1, value2, "bm");
            return (Criteria) this;
        }

        public Criteria andMcIsNull() {
            addCriterion("MC is null");
            return (Criteria) this;
        }

        public Criteria andMcIsNotNull() {
            addCriterion("MC is not null");
            return (Criteria) this;
        }

        public Criteria andMcEqualTo(String value) {
            addCriterion("MC =", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcNotEqualTo(String value) {
            addCriterion("MC <>", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcGreaterThan(String value) {
            addCriterion("MC >", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcGreaterThanOrEqualTo(String value) {
            addCriterion("MC >=", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcLessThan(String value) {
            addCriterion("MC <", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcLessThanOrEqualTo(String value) {
            addCriterion("MC <=", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcLike(String value) {
            addCriterion("MC like", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcNotLike(String value) {
            addCriterion("MC not like", value, "mc");
            return (Criteria) this;
        }

        public Criteria andMcIn(List<String> values) {
            addCriterion("MC in", values, "mc");
            return (Criteria) this;
        }

        public Criteria andMcNotIn(List<String> values) {
            addCriterion("MC not in", values, "mc");
            return (Criteria) this;
        }

        public Criteria andMcBetween(String value1, String value2) {
            addCriterion("MC between", value1, value2, "mc");
            return (Criteria) this;
        }

        public Criteria andMcNotBetween(String value1, String value2) {
            addCriterion("MC not between", value1, value2, "mc");
            return (Criteria) this;
        }

        public Criteria andFdPfjIsNull() {
            addCriterion("FD_PFJ is null");
            return (Criteria) this;
        }

        public Criteria andFdPfjIsNotNull() {
            addCriterion("FD_PFJ is not null");
            return (Criteria) this;
        }

        public Criteria andFdPfjEqualTo(BigDecimal value) {
            addCriterion("FD_PFJ =", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjNotEqualTo(BigDecimal value) {
            addCriterion("FD_PFJ <>", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjGreaterThan(BigDecimal value) {
            addCriterion("FD_PFJ >", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_PFJ >=", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjLessThan(BigDecimal value) {
            addCriterion("FD_PFJ <", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_PFJ <=", value, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjIn(List<BigDecimal> values) {
            addCriterion("FD_PFJ in", values, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjNotIn(List<BigDecimal> values) {
            addCriterion("FD_PFJ not in", values, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_PFJ between", value1, value2, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdPfjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_PFJ not between", value1, value2, "fdPfj");
            return (Criteria) this;
        }

        public Criteria andFdLsjIsNull() {
            addCriterion("FD_LSJ is null");
            return (Criteria) this;
        }

        public Criteria andFdLsjIsNotNull() {
            addCriterion("FD_LSJ is not null");
            return (Criteria) this;
        }

        public Criteria andFdLsjEqualTo(BigDecimal value) {
            addCriterion("FD_LSJ =", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjNotEqualTo(BigDecimal value) {
            addCriterion("FD_LSJ <>", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjGreaterThan(BigDecimal value) {
            addCriterion("FD_LSJ >", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_LSJ >=", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjLessThan(BigDecimal value) {
            addCriterion("FD_LSJ <", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_LSJ <=", value, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjIn(List<BigDecimal> values) {
            addCriterion("FD_LSJ in", values, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjNotIn(List<BigDecimal> values) {
            addCriterion("FD_LSJ not in", values, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_LSJ between", value1, value2, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdLsjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_LSJ not between", value1, value2, "fdLsj");
            return (Criteria) this;
        }

        public Criteria andFdHyjIsNull() {
            addCriterion("FD_HYJ is null");
            return (Criteria) this;
        }

        public Criteria andFdHyjIsNotNull() {
            addCriterion("FD_HYJ is not null");
            return (Criteria) this;
        }

        public Criteria andFdHyjEqualTo(BigDecimal value) {
            addCriterion("FD_HYJ =", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjNotEqualTo(BigDecimal value) {
            addCriterion("FD_HYJ <>", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjGreaterThan(BigDecimal value) {
            addCriterion("FD_HYJ >", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_HYJ >=", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjLessThan(BigDecimal value) {
            addCriterion("FD_HYJ <", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD_HYJ <=", value, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjIn(List<BigDecimal> values) {
            addCriterion("FD_HYJ in", values, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjNotIn(List<BigDecimal> values) {
            addCriterion("FD_HYJ not in", values, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_HYJ between", value1, value2, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFdHyjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD_HYJ not between", value1, value2, "fdHyj");
            return (Criteria) this;
        }

        public Criteria andFd1IsNull() {
            addCriterion("FD1 is null");
            return (Criteria) this;
        }

        public Criteria andFd1IsNotNull() {
            addCriterion("FD1 is not null");
            return (Criteria) this;
        }

        public Criteria andFd1EqualTo(BigDecimal value) {
            addCriterion("FD1 =", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1NotEqualTo(BigDecimal value) {
            addCriterion("FD1 <>", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1GreaterThan(BigDecimal value) {
            addCriterion("FD1 >", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD1 >=", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1LessThan(BigDecimal value) {
            addCriterion("FD1 <", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD1 <=", value, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1In(List<BigDecimal> values) {
            addCriterion("FD1 in", values, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1NotIn(List<BigDecimal> values) {
            addCriterion("FD1 not in", values, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD1 between", value1, value2, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD1 not between", value1, value2, "fd1");
            return (Criteria) this;
        }

        public Criteria andFd2IsNull() {
            addCriterion("FD2 is null");
            return (Criteria) this;
        }

        public Criteria andFd2IsNotNull() {
            addCriterion("FD2 is not null");
            return (Criteria) this;
        }

        public Criteria andFd2EqualTo(BigDecimal value) {
            addCriterion("FD2 =", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2NotEqualTo(BigDecimal value) {
            addCriterion("FD2 <>", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2GreaterThan(BigDecimal value) {
            addCriterion("FD2 >", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD2 >=", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2LessThan(BigDecimal value) {
            addCriterion("FD2 <", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD2 <=", value, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2In(List<BigDecimal> values) {
            addCriterion("FD2 in", values, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2NotIn(List<BigDecimal> values) {
            addCriterion("FD2 not in", values, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD2 between", value1, value2, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD2 not between", value1, value2, "fd2");
            return (Criteria) this;
        }

        public Criteria andFd3IsNull() {
            addCriterion("FD3 is null");
            return (Criteria) this;
        }

        public Criteria andFd3IsNotNull() {
            addCriterion("FD3 is not null");
            return (Criteria) this;
        }

        public Criteria andFd3EqualTo(BigDecimal value) {
            addCriterion("FD3 =", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3NotEqualTo(BigDecimal value) {
            addCriterion("FD3 <>", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3GreaterThan(BigDecimal value) {
            addCriterion("FD3 >", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD3 >=", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3LessThan(BigDecimal value) {
            addCriterion("FD3 <", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD3 <=", value, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3In(List<BigDecimal> values) {
            addCriterion("FD3 in", values, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3NotIn(List<BigDecimal> values) {
            addCriterion("FD3 not in", values, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD3 between", value1, value2, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd3NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD3 not between", value1, value2, "fd3");
            return (Criteria) this;
        }

        public Criteria andFd4IsNull() {
            addCriterion("FD4 is null");
            return (Criteria) this;
        }

        public Criteria andFd4IsNotNull() {
            addCriterion("FD4 is not null");
            return (Criteria) this;
        }

        public Criteria andFd4EqualTo(BigDecimal value) {
            addCriterion("FD4 =", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4NotEqualTo(BigDecimal value) {
            addCriterion("FD4 <>", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4GreaterThan(BigDecimal value) {
            addCriterion("FD4 >", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD4 >=", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4LessThan(BigDecimal value) {
            addCriterion("FD4 <", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD4 <=", value, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4In(List<BigDecimal> values) {
            addCriterion("FD4 in", values, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4NotIn(List<BigDecimal> values) {
            addCriterion("FD4 not in", values, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD4 between", value1, value2, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD4 not between", value1, value2, "fd4");
            return (Criteria) this;
        }

        public Criteria andFd5IsNull() {
            addCriterion("FD5 is null");
            return (Criteria) this;
        }

        public Criteria andFd5IsNotNull() {
            addCriterion("FD5 is not null");
            return (Criteria) this;
        }

        public Criteria andFd5EqualTo(BigDecimal value) {
            addCriterion("FD5 =", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5NotEqualTo(BigDecimal value) {
            addCriterion("FD5 <>", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5GreaterThan(BigDecimal value) {
            addCriterion("FD5 >", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FD5 >=", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5LessThan(BigDecimal value) {
            addCriterion("FD5 <", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("FD5 <=", value, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5In(List<BigDecimal> values) {
            addCriterion("FD5 in", values, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5NotIn(List<BigDecimal> values) {
            addCriterion("FD5 not in", values, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD5 between", value1, value2, "fd5");
            return (Criteria) this;
        }

        public Criteria andFd5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FD5 not between", value1, value2, "fd5");
            return (Criteria) this;
        }

        public Criteria andTclLrIsNull() {
            addCriterion("TCL_LR is null");
            return (Criteria) this;
        }

        public Criteria andTclLrIsNotNull() {
            addCriterion("TCL_LR is not null");
            return (Criteria) this;
        }

        public Criteria andTclLrEqualTo(BigDecimal value) {
            addCriterion("TCL_LR =", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrNotEqualTo(BigDecimal value) {
            addCriterion("TCL_LR <>", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrGreaterThan(BigDecimal value) {
            addCriterion("TCL_LR >", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_LR >=", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrLessThan(BigDecimal value) {
            addCriterion("TCL_LR <", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_LR <=", value, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrIn(List<BigDecimal> values) {
            addCriterion("TCL_LR in", values, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrNotIn(List<BigDecimal> values) {
            addCriterion("TCL_LR not in", values, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_LR between", value1, value2, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclLrNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_LR not between", value1, value2, "tclLr");
            return (Criteria) this;
        }

        public Criteria andTclJeIsNull() {
            addCriterion("TCL_JE is null");
            return (Criteria) this;
        }

        public Criteria andTclJeIsNotNull() {
            addCriterion("TCL_JE is not null");
            return (Criteria) this;
        }

        public Criteria andTclJeEqualTo(BigDecimal value) {
            addCriterion("TCL_JE =", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeNotEqualTo(BigDecimal value) {
            addCriterion("TCL_JE <>", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeGreaterThan(BigDecimal value) {
            addCriterion("TCL_JE >", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_JE >=", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeLessThan(BigDecimal value) {
            addCriterion("TCL_JE <", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_JE <=", value, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeIn(List<BigDecimal> values) {
            addCriterion("TCL_JE in", values, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeNotIn(List<BigDecimal> values) {
            addCriterion("TCL_JE not in", values, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_JE between", value1, value2, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclJeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_JE not between", value1, value2, "tclJe");
            return (Criteria) this;
        }

        public Criteria andTclSlIsNull() {
            addCriterion("TCL_SL is null");
            return (Criteria) this;
        }

        public Criteria andTclSlIsNotNull() {
            addCriterion("TCL_SL is not null");
            return (Criteria) this;
        }

        public Criteria andTclSlEqualTo(BigDecimal value) {
            addCriterion("TCL_SL =", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlNotEqualTo(BigDecimal value) {
            addCriterion("TCL_SL <>", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlGreaterThan(BigDecimal value) {
            addCriterion("TCL_SL >", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_SL >=", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlLessThan(BigDecimal value) {
            addCriterion("TCL_SL <", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TCL_SL <=", value, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlIn(List<BigDecimal> values) {
            addCriterion("TCL_SL in", values, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlNotIn(List<BigDecimal> values) {
            addCriterion("TCL_SL not in", values, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_SL between", value1, value2, "tclSl");
            return (Criteria) this;
        }

        public Criteria andTclSlNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TCL_SL not between", value1, value2, "tclSl");
            return (Criteria) this;
        }

        public Criteria andJfgzIsNull() {
            addCriterion("JFGZ is null");
            return (Criteria) this;
        }

        public Criteria andJfgzIsNotNull() {
            addCriterion("JFGZ is not null");
            return (Criteria) this;
        }

        public Criteria andJfgzEqualTo(String value) {
            addCriterion("JFGZ =", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzNotEqualTo(String value) {
            addCriterion("JFGZ <>", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzGreaterThan(String value) {
            addCriterion("JFGZ >", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzGreaterThanOrEqualTo(String value) {
            addCriterion("JFGZ >=", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzLessThan(String value) {
            addCriterion("JFGZ <", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzLessThanOrEqualTo(String value) {
            addCriterion("JFGZ <=", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzLike(String value) {
            addCriterion("JFGZ like", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzNotLike(String value) {
            addCriterion("JFGZ not like", value, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzIn(List<String> values) {
            addCriterion("JFGZ in", values, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzNotIn(List<String> values) {
            addCriterion("JFGZ not in", values, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzBetween(String value1, String value2) {
            addCriterion("JFGZ between", value1, value2, "jfgz");
            return (Criteria) this;
        }

        public Criteria andJfgzNotBetween(String value1, String value2) {
            addCriterion("JFGZ not between", value1, value2, "jfgz");
            return (Criteria) this;
        }

        public Criteria andFlIsNull() {
            addCriterion("FL is null");
            return (Criteria) this;
        }

        public Criteria andFlIsNotNull() {
            addCriterion("FL is not null");
            return (Criteria) this;
        }

        public Criteria andFlEqualTo(String value) {
            addCriterion("FL =", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlNotEqualTo(String value) {
            addCriterion("FL <>", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlGreaterThan(String value) {
            addCriterion("FL >", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlGreaterThanOrEqualTo(String value) {
            addCriterion("FL >=", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlLessThan(String value) {
            addCriterion("FL <", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlLessThanOrEqualTo(String value) {
            addCriterion("FL <=", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlLike(String value) {
            addCriterion("FL like", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlNotLike(String value) {
            addCriterion("FL not like", value, "fl");
            return (Criteria) this;
        }

        public Criteria andFlIn(List<String> values) {
            addCriterion("FL in", values, "fl");
            return (Criteria) this;
        }

        public Criteria andFlNotIn(List<String> values) {
            addCriterion("FL not in", values, "fl");
            return (Criteria) this;
        }

        public Criteria andFlBetween(String value1, String value2) {
            addCriterion("FL between", value1, value2, "fl");
            return (Criteria) this;
        }

        public Criteria andFlNotBetween(String value1, String value2) {
            addCriterion("FL not between", value1, value2, "fl");
            return (Criteria) this;
        }

        public Criteria andCcIsNull() {
            addCriterion("CC is null");
            return (Criteria) this;
        }

        public Criteria andCcIsNotNull() {
            addCriterion("CC is not null");
            return (Criteria) this;
        }

        public Criteria andCcEqualTo(Integer value) {
            addCriterion("CC =", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcNotEqualTo(Integer value) {
            addCriterion("CC <>", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcGreaterThan(Integer value) {
            addCriterion("CC >", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcGreaterThanOrEqualTo(Integer value) {
            addCriterion("CC >=", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcLessThan(Integer value) {
            addCriterion("CC <", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcLessThanOrEqualTo(Integer value) {
            addCriterion("CC <=", value, "cc");
            return (Criteria) this;
        }

        public Criteria andCcIn(List<Integer> values) {
            addCriterion("CC in", values, "cc");
            return (Criteria) this;
        }

        public Criteria andCcNotIn(List<Integer> values) {
            addCriterion("CC not in", values, "cc");
            return (Criteria) this;
        }

        public Criteria andCcBetween(Integer value1, Integer value2) {
            addCriterion("CC between", value1, value2, "cc");
            return (Criteria) this;
        }

        public Criteria andCcNotBetween(Integer value1, Integer value2) {
            addCriterion("CC not between", value1, value2, "cc");
            return (Criteria) this;
        }

        public Criteria andQyFlagIsNull() {
            addCriterion("QY_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andQyFlagIsNotNull() {
            addCriterion("QY_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andQyFlagEqualTo(String value) {
            addCriterion("QY_FLAG =", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagNotEqualTo(String value) {
            addCriterion("QY_FLAG <>", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagGreaterThan(String value) {
            addCriterion("QY_FLAG >", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagGreaterThanOrEqualTo(String value) {
            addCriterion("QY_FLAG >=", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagLessThan(String value) {
            addCriterion("QY_FLAG <", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagLessThanOrEqualTo(String value) {
            addCriterion("QY_FLAG <=", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagLike(String value) {
            addCriterion("QY_FLAG like", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagNotLike(String value) {
            addCriterion("QY_FLAG not like", value, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagIn(List<String> values) {
            addCriterion("QY_FLAG in", values, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagNotIn(List<String> values) {
            addCriterion("QY_FLAG not in", values, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagBetween(String value1, String value2) {
            addCriterion("QY_FLAG between", value1, value2, "qyFlag");
            return (Criteria) this;
        }

        public Criteria andQyFlagNotBetween(String value1, String value2) {
            addCriterion("QY_FLAG not between", value1, value2, "qyFlag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}